Overview

Dataset statistics

Number of variables15
Number of observations4920
Missing cells2326
Missing cells (%)3.2%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory843.8 KiB
Average record size in memory175.6 B

Variable types

NUM13
CAT2

Reproduction

Analysis started2020-04-09 14:32:24.844864
Analysis finished2020-04-09 14:33:39.078374
Versionpandas-profiling v2.5.0
Command linepandas_profiling --config_file config.yaml [YOUR_FILE.csv]
Download configurationconfig.yaml
Country Code has a high cardinality: 82 distinct values High cardinality
Country Name has a high cardinality: 82 distinct values High cardinality
Country Name is highly correlated with Country CodeHigh Correlation
Country Code is highly correlated with Country NameHigh Correlation
Air transport, freight (million ton-km) has 1688 (34.3%) missing values Missing
Cereal yield (kg per hectare) has 180 (3.7%) missing values Missing
GDP growth (annual %) has 98 (2.0%) missing values Missing
GDP per capita (constant 2010 US$) has 180 (3.7%) missing values Missing
Adjusted savings: education expenditure (% of GNI) has 180 (3.7%) missing values Missing
Net flows from UN agencies US$ has 1858 (37.8%) zeros Zeros
Mobile cellular subscriptions (per 100 people) has 2533 (51.5%) zeros Zeros

Variables

Year
Real number (ℝ≥0)

Distinct count60
Unique (%)1.2%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean1989.5
Minimum1960
Maximum2019
Zeros0
Zeros (%)0.0%
Memory size38.5 KiB

Quantile statistics

Minimum1960
5-th percentile1962.95
Q11974.75
median1989.5
Q32004.25
95-th percentile2016.05
Maximum2019
Range59
Interquartile range (IQR)29.5

Descriptive statistics

Standard deviation17.31986252
Coefficient of variation (CV)0.008705635848
Kurtosis-1.200667431
Mean1989.5
Median Absolute Deviation (MAD)15
Skewness0
Sum9788340
Variance299.9776377
Histogram with fixed size bins (bins=10)
Histogram with variable size bins (bins=[1960. 1960.5 2018.5 2019. ], "bayesian blocks" binning strategy used)
ValueCountFrequency (%) 
2019 82 1.7%
 
2015 82 1.7%
 
2009 82 1.7%
 
2005 82 1.7%
 
2001 82 1.7%
 
1997 82 1.7%
 
1993 82 1.7%
 
1989 82 1.7%
 
1985 82 1.7%
 
1981 82 1.7%
 
Other values (50) 4100 83.3%
 
ValueCountFrequency (%) 
1960 82 1.7%
 
1961 82 1.7%
 
1962 82 1.7%
 
1963 82 1.7%
 
1964 82 1.7%
 
ValueCountFrequency (%) 
2019 82 1.7%
 
2018 82 1.7%
 
2017 82 1.7%
 
2016 82 1.7%
 
2015 82 1.7%
 

Country Code
Categorical

HIGH CARDINALITY
HIGH CORRELATION
UNIFORM
Distinct count82
Unique (%)1.7%
Missing0
Missing (%)0.0%
Memory size19.3 KiB
YEM
 
60
GIN
 
60
ZAF
 
60
BRA
 
60
TTO
 
60
Other values (77)
4620
ValueCountFrequency (%) 
YEM 60 1.2%
 
GIN 60 1.2%
 
ZAF 60 1.2%
 
BRA 60 1.2%
 
TTO 60 1.2%
 
DOM 60 1.2%
 
CHN 60 1.2%
 
GRL 60 1.2%
 
SPM 60 1.2%
 
NOR 60 1.2%
 
Other values (72) 4320 87.8%
 

Length

Max length3
Mean length3
Min length3
ValueCountFrequency (%) 
Uppercase_Letter 25 100.0%
 
ValueCountFrequency (%) 
Latin 25 100.0%
 
ValueCountFrequency (%) 
ASCII 25 100.0%
 

Country Name
Categorical

HIGH CARDINALITY
HIGH CORRELATION
UNIFORM
Distinct count82
Unique (%)1.7%
Missing0
Missing (%)0.0%
Memory size19.3 KiB
Vanuatu
 
60
Trinidad and Tobago
 
60
Samoa
 
60
Hong Kong SAR, China
 
60
Senegal
 
60
Other values (77)
4620
ValueCountFrequency (%) 
Vanuatu 60 1.2%
 
Trinidad and Tobago 60 1.2%
 
Samoa 60 1.2%
 
Hong Kong SAR, China 60 1.2%
 
Senegal 60 1.2%
 
New Caledonia 60 1.2%
 
Russian Federation 60 1.2%
 
Iran, Islamic Rep. 60 1.2%
 
Morocco 60 1.2%
 
Haiti 60 1.2%
 
Other values (72) 4320 87.8%
 

Length

Max length25
Mean length9.804878049
Min length4
ValueCountFrequency (%) 
Lowercase_Letter 26 48.1%
 
Uppercase_Letter 23 42.6%
 
Other_Punctuation 2 3.7%
 
Final_Punctuation 1 1.9%
 
Dash_Punctuation 1 1.9%
 
Space_Separator 1 1.9%
 
ValueCountFrequency (%) 
Latin 49 90.7%
 
Common 5 9.3%
 
ValueCountFrequency (%) 
ASCII 53 98.1%
 
Punctuation 1 1.9%
 

Air transport, freight (million ton-km)
Real number (ℝ≥0)

MISSING
Distinct count2244
Unique (%)69.4%
Missing1688
Missing (%)34.3%
Infinite0
Infinite (%)0.0%
Mean1126.2264004977799
Minimum0.0
Maximum42985.29522
Zeros31
Zeros (%)0.6%
Memory size38.5 KiB

Quantile statistics

Minimum0
5-th percentile0.200000003
Q14.699999809
median58.09999847
Q3450.4790734
95-th percentile6260.061511
Maximum42985.29522
Range42985.29522
Interquartile range (IQR)445.7790736

Descriptive statistics

Standard deviation3842.346801
Coefficient of variation (CV)3.411700169
Kurtosis52.82780074
Mean1126.2264
Median Absolute Deviation (MAD)1656.215938
Skewness6.574798613
Sum3639963.726
Variance14763628.94
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%) 
0.100000002 77 1.6%
 
0.200000003 36 0.7%
 
0 31 0.6%
 
0.400000006 20 0.4%
 
1.899999976 17 0.3%
 
0.5 17 0.3%
 
1.200000048 15 0.3%
 
0.600000024 15 0.3%
 
0.800000012 15 0.3%
 
3 14 0.3%
 
Other values (2234) 2975 60.5%
 
(Missing) 1688 34.3%
 
ValueCountFrequency (%) 
0 31 0.6%
 
0.003641454 1 < 0.1%
 
0.005467548 1 < 0.1%
 
0.005484 2 < 0.1%
 
0.007249968 1 < 0.1%
 
ValueCountFrequency (%) 
42985.29522 1 < 0.1%
 
41591.55177 1 < 0.1%
 
40617.739 1 < 0.1%
 
39881.895 1 < 0.1%
 
39621.91354 1 < 0.1%
 
Distinct count4546
Unique (%)92.4%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean0.2803873166239837
Minimum0.000408909
Maximum3.4984320710000003
Zeros0
Zeros (%)0.0%
Memory size38.5 KiB

Quantile statistics

Minimum0.000408909
5-th percentile0.0178277015
Q10.08329795375
median0.1749054115
Q30.3091584552
95-th percentile0.887812817
Maximum3.498432071
Range3.498023162
Interquartile range (IQR)0.2258605015

Descriptive statistics

Standard deviation0.4000240112
Coefficient of variation (CV)1.426683689
Kurtosis20.5626603
Mean0.2803873166
Median Absolute Deviation (MAD)0.2190572296
Skewness4.092028687
Sum1379.505598
Variance0.1600192095
Histogram with fixed size bins (bins=10)
Histogram with variable size bins (bins=[4.08909000e-04 4.32690500e-04 1.36650850e-03 7.51583150e-03 7.62456600e-03 ... 8.55993476e-01 8.87725730e-01 8.88937146e-01 2.27035335e+00 3.49843207e+00], "bayesian blocks" binning strategy used)
ValueCountFrequency (%) 
0.887812817 33 0.7%
 
0.007518797 26 0.5%
 
0.237132251 4 0.1%
 
0.132205765 4 0.1%
 
0.155376857 4 0.1%
 
2.235400361 4 0.1%
 
0.129423765 2 < 0.1%
 
0.21318447 2 < 0.1%
 
0.069203927 2 < 0.1%
 
0.195726221 2 < 0.1%
 
Other values (4536) 4837 98.3%
 
ValueCountFrequency (%) 
0.000408909 1 < 0.1%
 
0.000413826 1 < 0.1%
 
0.000419131 1 < 0.1%
 
0.000425164 1 < 0.1%
 
0.000425351 1 < 0.1%
 
ValueCountFrequency (%) 
3.498432071 1 < 0.1%
 
3.44658173 1 < 0.1%
 
3.400051498 1 < 0.1%
 
3.384163745 1 < 0.1%
 
3.327256736 1 < 0.1%
 

Cereal yield (kg per hectare)
Real number (ℝ≥0)

MISSING
Distinct count4119
Unique (%)86.9%
Missing180
Missing (%)3.7%
Infinite0
Infinite (%)0.0%
Mean2522.194603195612
Minimum63.2
Maximum28130.1
Zeros0
Zeros (%)0.0%
Memory size38.5 KiB

Quantile statistics

Minimum63.2
5-th percentile571.685
Q11238.7
median1959.35
Q33245.025
95-th percentile6080.83996
Maximum28130.1
Range28066.9
Interquartile range (IQR)2006.325

Descriptive statistics

Standard deviation2078.448199
Coefficient of variation (CV)0.8240633756
Kurtosis32.39710646
Mean2522.194603
Median Absolute Deviation (MAD)1367.364517
Skewness4.087334524
Sum11955202.42
Variance4319946.914
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%) 
1743.2 33 0.7%
 
1166.7 18 0.4%
 
500 16 0.3%
 
2000.4 12 0.2%
 
2791.8 6 0.1%
 
1000 6 0.1%
 
520 5 0.1%
 
2000 4 0.1%
 
1083.9 4 0.1%
 
1512.6 4 0.1%
 
Other values (4109) 4632 94.1%
 
(Missing) 180 3.7%
 
ValueCountFrequency (%) 
63.2 1 < 0.1%
 
132.3 1 < 0.1%
 
150.7 1 < 0.1%
 
152.6 1 < 0.1%
 
177.6 1 < 0.1%
 
ValueCountFrequency (%) 
28130.1 1 < 0.1%
 
26761.7 1 < 0.1%
 
25717.34076 1 < 0.1%
 
24758.59738 1 < 0.1%
 
23576.3 1 < 0.1%
 
Distinct count3837
Unique (%)78.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean80.47576899095935
Minimum4.07
Maximum233.29
Zeros0
Zeros (%)0.0%
Memory size38.5 KiB

Quantile statistics

Minimum4.07
5-th percentile25.2375
Q152.98
median83.69349589
Q3102.6325
95-th percentile135.655608
Maximum233.29
Range229.22
Interquartile range (IQR)49.6525

Descriptive statistics

Standard deviation34.55442795
Coefficient of variation (CV)0.4293767973
Kurtosis0.1466659244
Mean80.47576899
Median Absolute Deviation (MAD)28.13896148
Skewness0.2374505009
Sum395940.7834
Variance1194.008491
Histogram with fixed size bins (bins=10)
Histogram with variable size bins (bins=[ 4.07 13.1 20.18 39.995 84.735 ... 131.895 147.595 161.77 194.465 233.29 ], "bayesian blocks" binning strategy used)
ValueCountFrequency (%) 
122.84 33 0.7%
 
98.03 7 0.1%
 
96.48 5 0.1%
 
81.15 5 0.1%
 
71.47 5 0.1%
 
104.21 5 0.1%
 
100.95 4 0.1%
 
99.06 4 0.1%
 
34.35 4 0.1%
 
103.51 4 0.1%
 
Other values (3827) 4844 98.5%
 
ValueCountFrequency (%) 
4.07 2 < 0.1%
 
4.13 1 < 0.1%
 
4.26 1 < 0.1%
 
4.41 1 < 0.1%
 
4.51 1 < 0.1%
 
ValueCountFrequency (%) 
233.29 1 < 0.1%
 
225.68 1 < 0.1%
 
223.02 1 < 0.1%
 
217.96 1 < 0.1%
 
214.47 1 < 0.1%
 

GDP growth (annual %)
Real number (ℝ)

MISSING
Distinct count4013
Unique (%)83.2%
Missing98
Missing (%)2.0%
Infinite0
Infinite (%)0.0%
Mean3.879247839898797
Minimum-34.80863877
Maximum81.88779671
Zeros9
Zeros (%)0.2%
Memory size38.5 KiB

Quantile statistics

Minimum-34.80863877
5-th percentile-3.910967458
Q11.808638519
median4.120806448
Q36.500003872
95-th percentile11.56314972
Maximum81.88779671
Range116.6964355
Interquartile range (IQR)4.691365353

Descriptive statistics

Standard deviation6.172776567
Coefficient of variation (CV)1.591230265
Kurtosis21.3941554
Mean3.87924784
Median Absolute Deviation (MAD)3.682059996
Skewness-1.073579631
Sum18705.73308
Variance38.10317055
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%) 
9.202676489 42 0.9%
 
6.547619053 36 0.7%
 
-34.80863877 35 0.7%
 
6.29349386 32 0.7%
 
6.004178731 32 0.7%
 
-2.999995642 31 0.6%
 
3.764443407 30 0.6%
 
3.299938845 28 0.6%
 
3.805855668 26 0.5%
 
5.069963948 26 0.5%
 
Other values (4003) 4504 91.5%
 
(Missing) 98 2.0%
 
ValueCountFrequency (%) 
-34.80863877 35 0.7%
 
-28.09997973 1 < 0.1%
 
-27.5264732 1 < 0.1%
 
-27.27 4 0.1%
 
-26.47878886 1 < 0.1%
 
ValueCountFrequency (%) 
81.88779671 1 < 0.1%
 
66.21908378 1 < 0.1%
 
64.08129419 1 < 0.1%
 
41.67729234 1 < 0.1%
 
35.88010245 1 < 0.1%
 

GDP per capita (constant 2010 US$)
Real number (ℝ≥0)

MISSING
Distinct count4019
Unique (%)84.8%
Missing180
Missing (%)3.7%
Infinite0
Infinite (%)0.0%
Mean11061.44256718789
Minimum132.3031881
Maximum116232.75300000001
Zeros0
Zeros (%)0.0%
Memory size38.5 KiB

Quantile statistics

Minimum132.3031881
5-th percentile377.5082811
Q11107.48193
median2968.206356
Q313857.13306
95-th percentile45809.00542
Maximum116232.753
Range116100.4498
Interquartile range (IQR)12749.65113

Descriptive statistics

Standard deviation17183.099
Coefficient of variation (CV)1.553422973
Kurtosis7.457664365
Mean11061.44257
Median Absolute Deviation (MAD)12195.74079
Skewness2.508953798
Sum52431237.77
Variance295258891.3
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%) 
1325.675038 41 0.8%
 
2404.941914 34 0.7%
 
509.9874554 34 0.7%
 
1298.609031 31 0.6%
 
1001.407006 31 0.6%
 
9883.404239 30 0.6%
 
494.2807214 29 0.6%
 
513.1941514 27 0.5%
 
422.9592419 25 0.5%
 
377.5082811 25 0.5%
 
Other values (4009) 4433 90.1%
 
(Missing) 180 3.7%
 
ValueCountFrequency (%) 
132.3031881 2 < 0.1%
 
141.2763632 2 < 0.1%
 
142.3876738 2 < 0.1%
 
144.9863117 1 < 0.1%
 
150.7744946 1 < 0.1%
 
ValueCountFrequency (%) 
116232.753 1 < 0.1%
 
113095.3373 1 < 0.1%
 
109318.6357 1 < 0.1%
 
103766.654 1 < 0.1%
 
103604.9068 16 0.3%
 

Net flows from UN agencies US$
Real number (ℝ)

ZEROS
Distinct count2853
Unique (%)58.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean11466115.198174028
Minimum-12103673.93
Maximum231800000.3
Zeros1858
Zeros (%)37.8%
Memory size38.5 KiB

Quantile statistics

Minimum-12103673.93
5-th percentile0
Q10
median2040000.025
Q311950315.43
95-th percentile52214499.27
Maximum231800000.3
Range243903674.2
Interquartile range (IQR)11950315.43

Descriptive statistics

Standard deviation23404737.68
Coefficient of variation (CV)2.041209012
Kurtosis19.87964151
Mean11466115.2
Median Absolute Deviation (MAD)13954478.97
Skewness3.91369005
Sum5.641328678e+10
Variance5.477817457e+14
Histogram with fixed size bins (bins=10)
Histogram with variable size bins (bins=[-1.21036739e+07 -1.49999978e+05 -4.99999989e+03 4.99999989e+03 2.49999994e+04 ... 5.25649997e+07 6.74391869e+07 1.07220000e+08 1.45674998e+08 2.31800000e+08], "bayesian blocks" binning strategy used)
ValueCountFrequency (%) 
0 1858 37.8%
 
9999.999776 23 0.5%
 
19999.99955 17 0.3%
 
39999.99911 11 0.2%
 
50000.00075 6 0.1%
 
59999.99866 5 0.1%
 
29999.99933 4 0.1%
 
839999.9738 4 0.1%
 
119999.9973 3 0.1%
 
1990000.01 3 0.1%
 
Other values (2843) 2986 60.7%
 
ValueCountFrequency (%) 
-12103673.93 1 < 0.1%
 
-189999.9532 1 < 0.1%
 
-110000.0031 1 < 0.1%
 
-89999.9961 1 < 0.1%
 
-69999.99654 1 < 0.1%
 
ValueCountFrequency (%) 
231800000.3 1 < 0.1%
 
216099996.3 1 < 0.1%
 
202119997.4 1 < 0.1%
 
199579997.5 1 < 0.1%
 
194079996.2 1 < 0.1%
 
Distinct count4462
Unique (%)90.7%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean64.42258767606707
Minimum18.907
Maximum84.68048780000001
Zeros0
Zeros (%)0.0%
Memory size38.5 KiB

Quantile statistics

Minimum18.907
5-th percentile43.50375
Q157.0875
median66.5725
Q373.02275
95-th percentile79.64165156
Maximum84.6804878
Range65.7734878
Interquartile range (IQR)15.93525

Descriptive statistics

Standard deviation11.20915017
Coefficient of variation (CV)0.1739941002
Kurtosis-0.1634276092
Mean64.42258768
Median Absolute Deviation (MAD)9.174424937
Skewness-0.6532269751
Sum316959.1314
Variance125.6450476
Histogram with fixed size bins (bins=10)
Histogram with variable size bins (bins=[18.907 32.1145 36.6575 43.1995 49.2395 ... 68.16334147 75.47873052 78.80170732 82.60902439 84.6804878 ], "bayesian blocks" binning strategy used)
ValueCountFrequency (%) 
63.41463415 19 0.4%
 
72.57073171 4 0.1%
 
78.63414634 4 0.1%
 
72.43219512 4 0.1%
 
80.34390244 4 0.1%
 
68.231 3 0.1%
 
81.15609756 3 0.1%
 
76.43414634 3 0.1%
 
63.915 3 0.1%
 
80.99756098 3 0.1%
 
Other values (4452) 4870 99.0%
 
ValueCountFrequency (%) 
18.907 1 < 0.1%
 
19.725 1 < 0.1%
 
20.317 1 < 0.1%
 
22.744 1 < 0.1%
 
23.595 1 < 0.1%
 
ValueCountFrequency (%) 
84.6804878 1 < 0.1%
 
84.41719321 1 < 0.1%
 
84.27804878 1 < 0.1%
 
84.26553451 1 < 0.1%
 
84.22682927 1 < 0.1%
 
Distinct count2222
Unique (%)45.2%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean24.30426673748496
Minimum0.0
Maximum269.9753789
Zeros2533
Zeros (%)51.5%
Memory size38.5 KiB

Quantile statistics

Minimum0
5-th percentile0
Q10
median0
Q330.44611923
95-th percentile119.5103555
Maximum269.9753789
Range269.9753789
Interquartile range (IQR)30.44611923

Descriptive statistics

Standard deviation43.42740451
Coefficient of variation (CV)1.786822247
Kurtosis2.352470084
Mean24.30426674
Median Absolute Deviation (MAD)33.90628271
Skewness1.774764492
Sum119576.9923
Variance1885.939462
Histogram with fixed size bins (bins=10)
Histogram with variable size bins (bins=[0.00000000e+00 3.13500000e-05 1.70663150e-03 1.95403905e-02 1.03144484e-01 ... 8.16500322e+01 1.23115616e+02 1.57574905e+02 1.82495764e+02 2.69975379e+02], "bayesian blocks" binning strategy used)
ValueCountFrequency (%) 
0 2533 51.5%
 
0.20003331 23 0.5%
 
2.117815497 8 0.2%
 
8.686735161 2 < 0.1%
 
0.127477599 2 < 0.1%
 
45.05678729 2 < 0.1%
 
47.20970229 2 < 0.1%
 
80.34784611 2 < 0.1%
 
2.781872012 2 < 0.1%
 
17.80689828 2 < 0.1%
 
Other values (2212) 2342 47.6%
 
ValueCountFrequency (%) 
0 2533 51.5%
 
6.27e-05 2 < 0.1%
 
0.000202709 1 < 0.1%
 
0.000231516 1 < 0.1%
 
0.000255894 1 < 0.1%
 
ValueCountFrequency (%) 
269.9753789 1 < 0.1%
 
251.7650057 1 < 0.1%
 
248.1756094 1 < 0.1%
 
242.7675438 1 < 0.1%
 
239.4366561 1 < 0.1%
 
Distinct count4598
Unique (%)93.5%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean166.04292663114347
Minimum0.098624524
Maximum7096.190476000001
Zeros0
Zeros (%)0.0%
Memory size38.5 KiB

Quantile statistics

Minimum0.098624524
5-th percentile2.125141997
Q115.06737122
median44.30872288
Q3126.2241598
95-th percentile431.3567249
Maximum7096.190476
Range7096.091851
Interquartile range (IQR)111.1567886

Descriptive statistics

Standard deviation618.9281776
Coefficient of variation (CV)3.727519083
Kurtosis81.26953713
Mean166.0429266
Median Absolute Deviation (MAD)194.9035239
Skewness8.76295495
Sum816931.199
Variance383072.089
Histogram with fixed size bins (bins=10)
Histogram with variable size bins (bins=[9.86245240e-02 1.36113625e-01 1.38684371e-01 1.63447468e-01 6.41591570e-01 ... 6.12339448e+02 6.25730708e+02 1.23310529e+03 3.17318627e+03 7.09619048e+03], "bayesian blocks" binning strategy used)
ValueCountFrequency (%) 
2.009235158 4 0.1%
 
9.883256547 4 0.1%
 
335.3482759 4 0.1%
 
70.33579208 4 0.1%
 
2.695952058 2 < 0.1%
 
11.68062429 2 < 0.1%
 
5.072338029 2 < 0.1%
 
10.84374328 2 < 0.1%
 
548.2 2 < 0.1%
 
128.3366211 2 < 0.1%
 
Other values (4588) 4892 99.4%
 
ValueCountFrequency (%) 
0.098624524 2 < 0.1%
 
0.102429031 1 < 0.1%
 
0.106526193 1 < 0.1%
 
0.110038045 1 < 0.1%
 
0.114720515 1 < 0.1%
 
ValueCountFrequency (%) 
7096.190476 1 < 0.1%
 
7039.714286 1 < 0.1%
 
7012.945042 1 < 0.1%
 
6987.238095 1 < 0.1%
 
6944.095238 1 < 0.1%
 
Distinct count1424
Unique (%)30.0%
Missing180
Missing (%)3.7%
Infinite0
Infinite (%)0.0%
Mean3.833963513003164
Minimum0.3
Maximum68.15293
Zeros0
Zeros (%)0.0%
Memory size38.5 KiB

Quantile statistics

Minimum0.3
5-th percentile1.17996361
Q12.3
median3.6
Q34.9
95-th percentile7.3400899
Maximum68.15293
Range67.85293
Interquartile range (IQR)2.6

Descriptive statistics

Standard deviation2.61597457
Coefficient of variation (CV)0.6823159795
Kurtosis182.2421634
Mean3.833963513
Median Absolute Deviation (MAD)1.590551322
Skewness9.04544888
Sum18172.98705
Variance6.84332295
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%) 
3.6 111 2.3%
 
1.8 93 1.9%
 
4.1 87 1.8%
 
5 71 1.4%
 
2.9 63 1.3%
 
3.9 60 1.2%
 
3.3 53 1.1%
 
6.9 50 1.0%
 
2.3 50 1.0%
 
1.46 50 1.0%
 
Other values (1414) 4052 82.4%
 
(Missing) 180 3.7%
 
ValueCountFrequency (%) 
0.3 1 < 0.1%
 
0.345079976 1 < 0.1%
 
0.3952019 1 < 0.1%
 
0.4 1 < 0.1%
 
0.41536646 1 < 0.1%
 
ValueCountFrequency (%) 
68.15293 1 < 0.1%
 
61.09475 1 < 0.1%
 
57.30059 1 < 0.1%
 
45.98960093 1 < 0.1%
 
37.72159 1 < 0.1%
 
Distinct count4495
Unique (%)91.4%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean52.481205193865044
Minimum0.0
Maximum96.94
Zeros27
Zeros (%)0.5%
Memory size38.5 KiB

Quantile statistics

Minimum0
5-th percentile14.62365
Q129.41225
median53.7495
Q374.6665
95-th percentile88.4172
Maximum96.94
Range96.94
Interquartile range (IQR)45.25425

Descriptive statistics

Standard deviation24.57168195
Coefficient of variation (CV)0.4681996509
Kurtosis-1.165495114
Mean52.48120519
Median Absolute Deviation (MAD)21.2180731
Skewness-0.1057578402
Sum258207.5296
Variance603.7675539
Histogram with fixed size bins (bins=10)
Histogram with variable size bins (bins=[0.00000e+00 1.05000e-02 5.64000e+00 6.45750e+00 1.18045e+01 ... 8.13770e+01 8.18110e+01 8.74660e+01 9.21570e+01 9.69400e+01], "bayesian blocks" binning strategy used)
ValueCountFrequency (%) 
0 27 0.5%
 
78.8 10 0.2%
 
20.2 8 0.2%
 
82.816 5 0.1%
 
82.6 4 0.1%
 
22.325 4 0.1%
 
82.708 4 0.1%
 
24.839 3 0.1%
 
47.347 3 0.1%
 
59 3 0.1%
 
Other values (4485) 4849 98.6%
 
ValueCountFrequency (%) 
0 27 0.5%
 
0.021 1 < 0.1%
 
0.168 1 < 0.1%
 
0.483 1 < 0.1%
 
0.906 1 < 0.1%
 
ValueCountFrequency (%) 
96.94 1 < 0.1%
 
96.903 1 < 0.1%
 
96.866 1 < 0.1%
 
96.829 1 < 0.1%
 
96.682 1 < 0.1%
 

Interactions

Correlations

Pearson's r

The Pearson's correlation coefficient (r) is a measure of linear correlation between two variables. It's value lies between -1 and +1, -1 indicating total negative linear correlation, 0 indicating no linear correlation and 1 indicating total positive linear correlation. Furthermore, r is invariant under separate changes in location and scale of the two variables, implying that for a linear function the angle to the x-axis does not affect r.

To calculate r for two variables X and Y, one divides the covariance of X and Y by the product of their standard deviations.

Spearman's ρ

The Spearman's rank correlation coefficient (ρ) is a measure of monotonic correlation between two variables, and is therefore better in catching nonlinear monotonic correlations than Pearson's r. It's value lies between -1 and +1, -1 indicating total negative monotonic correlation, 0 indicating no monotonic correlation and 1 indicating total positive monotonic correlation.

To calculate ρ for two variables X and Y, one divides the covariance of the rank variables of X and Y by the product of their standard deviations.

Kendall's τ

Similarly to Spearman's rank correlation coefficient, the Kendall rank correlation coefficient (τ) measures ordinal association between two variables. It's value lies between -1 and +1, -1 indicating total negative correlation, 0 indicating no correlation and 1 indicating total positive correlation.

To calculate τ for two variables X and Y, one determines the number of concordant and discordant pairs of observations. τ is given by the number of concordant pairs minus the discordant pairs divided by the total number of pairs.

Missing values

Sample

First rows

YearCountry CodeCountry NameAir transport, freight (million ton-km)Arable land (hectares per person)Cereal yield (kg per hectare)Food production index (2004-2006 = 100)GDP growth (annual %)GDP per capita (constant 2010 US$)Net flows from UN agencies US$Life expectancy at birth, total (years)Mobile cellular subscriptions (per 100 people)Population density (people per sq. km of land area)Adjusted savings: education expenditure (% of GNI)Rural population (% of total population)
01960AREUnited Arab EmiratesNaN0.0496051166.74.0716.526857103604.90680.0000051.5370.2000331.419262NaN26.500
11961AREUnited Arab EmiratesNaN0.0496051166.74.0716.526857103604.90680.0000052.5600.2000331.419262NaN25.617
21962AREUnited Arab EmiratesNaN0.0445961166.74.1316.526857103604.90680.0000053.5730.2000331.578682NaN24.752
31963AREUnited Arab EmiratesNaN0.0399581166.74.2616.526857103604.90680.0000054.5720.2000331.761898NaN23.907
41964AREUnited Arab EmiratesNaN0.0362221166.74.4116.526857103604.90680.0000055.5550.2000331.943664NaN23.081
51965AREUnited Arab EmiratesNaN0.0333651166.74.5116.526857103604.90680.0000056.5230.2000332.110068NaN22.277
61966AREUnited Arab EmiratesNaN0.0375061166.74.6416.526857103604.90680.0000057.4820.2000332.252549NaN21.492
71967AREUnited Arab EmiratesNaN0.0353421166.74.7916.526857103604.90680.0000058.4320.2000332.390467NaN20.728
81968AREUnited Arab EmiratesNaN0.0328541166.74.9916.526857103604.90680.0000059.3750.2000332.571487NaN20.200
91969AREUnited Arab EmiratesNaN0.0295411166.75.2916.526857103604.906819999.9995560.3040.2000332.859842NaN20.200

Last rows

YearCountry CodeCountry NameAir transport, freight (million ton-km)Arable land (hectares per person)Cereal yield (kg per hectare)Food production index (2004-2006 = 100)GDP growth (annual %)GDP per capita (constant 2010 US$)Net flows from UN agencies US$Life expectancy at birth, total (years)Mobile cellular subscriptions (per 100 people)Population density (people per sq. km of land area)Adjusted savings: education expenditure (% of GNI)Rural population (% of total population)
49102010TWNTaiwan17193.87740.0801525524.900000119.96000010.6361404550.45359638390000.3574.40900062.755431142.4877401.7950.774000
49112011TWNTaiwan16764.86900.0792485707.000000123.3900009.5509144961.23468952399999.9874.70800071.649451143.1721091.7949.489000
49122012TWNTaiwan15568.75300.0784195825.200000127.7000007.8596275325.16010658384354.2775.01300080.346038143.8713901.7948.235000
49132013TWNTaiwan16053.73310.0778855894.200000129.7900007.7686155710.58787339328122.3875.32100088.305749144.5834531.7946.987000
49142014TWNTaiwan17822.58100.0774775891.900000131.8600007.2995196096.48781749705844.7675.62900091.899629145.3173521.7945.741000
49152015TWNTaiwan19805.63000.0867845896.200000135.9100006.9053176484.43594855491829.9375.92800091.835388146.0576421.7944.500000
49162016TWNTaiwan21304.58510.0862435980.900000139.0300006.7366756883.89542540237509.7976.21000096.526617146.8506781.7943.264000
49172017TWNTaiwan23323.61470.0820476029.000000133.9131246.7570087308.06536634845905.5476.470000103.438421147.6740511.7942.040000
49182018TWNTaiwan25256.20710.0849615943.541863136.4582116.5669747752.55952551592781.6976.050480115.525812148.3488331.7940.848000
49192019TWNTaiwanNaN0.0860755986.074230137.9685686.7538947084.0637110.0076.262667100.814841147.2119831.7942.713022